CouponHandlingRule

Entity Definition

Logical Name : CouponHandlingRule
Physical Name : RU_HN_CPN

A rule that states how a particular coupon should be processed. For example, store coupons are normally taken as a markdown against the purchased ITEM, whereas manufacturer coupons are redeemed in full.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CouponTypeCode (PK) A code to denote the type of coupon, e.g. raincheck, manufacturer coupon, electronic coupon. TY_CPN Code2 char(2)
Description A description of the coupon, e.g. money off a particular ITEM. DE_CPN DescriptionShort varchar(255)
CouponValueAccountingDispositionCode The disposition code for the coupon, e.g. store coupons are charged as an expense or markdown. DP_CPN_VL Code4 char(4)

Relationships

Parent Entity Verb Phrase Child Entity
CouponHandlingRule refers to ManufacturerCouponFamily

Logical Views containing CouponHandlingRule

Logical View
Logical 01100 - Item Selling Rules - Macro View
Logical 01120 - Item Selling Rules - Manufacturer Coupon View
Logical 02333 - Retail Transaction - Tender - Coupon View